Tabela TimeStampLock

Definicja tabeli TimeStampLock

Name

TimeStampLock

Code

TimeStampLock

Comment

 


Lista kolumn tabeli TimeStampLock

Name

Code

StartDT

StartDT

StopDT

StopDT

InsertDT

InsertDT

SessionID

SessionID

TimeStampLockID

TimeStampLockID

TimePatternID

TimePatternID

PersonID

PersonID


Kolumna StartDT tabeli TimeStampLock

Definicja kolumny StartDT tabeli TimeStampLock

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli TimeStampLock

Definicja kolumny StopDT tabeli TimeStampLock

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna InsertDT tabeli TimeStampLock

Definicja kolumny InsertDT tabeli TimeStampLock

Name

InsertDT

Code

InsertDT

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna SessionID tabeli TimeStampLock

Definicja kolumny SessionID tabeli TimeStampLock

Name

SessionID

Code

SessionID

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna TimeStampLockID tabeli TimeStampLock

Definicja kolumny TimeStampLockID tabeli TimeStampLock

Name

TimeStampLockID

Code

TimeStampLockID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna TimePatternID tabeli TimeStampLock

Definicja kolumny TimePatternID tabeli TimeStampLock

Name

TimePatternID

Code

TimePatternID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli TimeStampLock

Definicja kolumny PersonID tabeli TimeStampLock

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID pacjenta


Lista kluczy tabeli TimeStampLock

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli TimeStampLock

Definicja klucza Identifier_1 tabeli TimeStampLock

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment